-- 快方配送时间
ALTER TABLE `ecs_order_info`
ADD COLUMN `delivery_time`  int(10) UNSIGNED NOT NULL COMMENT '快方配送时间' AFTER `public`;

-- ----------------------------
-- Table structure for `ecs_sync` 同步信息表
-- ----------------------------
DROP TABLE IF EXISTS `ecs_sync`;
CREATE TABLE `ecs_sync` (
`sync_id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`sync_type`  char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型说明' ,
`user_id`  int(11) UNSIGNED NOT NULL ,
`order_id`  int(11) UNSIGNED NOT NULL ,
`sync_status`  tinyint(2) UNSIGNED NOT NULL COMMENT '同步状态 0 未同步，1同步成功，2同步失败' ,
PRIMARY KEY (`sync_id`),
INDEX `id` (`sync_id`, `user_id`, `order_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='同步信息表'
AUTO_INCREMENT=1
;
--  同步信息表添加备注字段
ALTER TABLE `ecs_sync`
ADD COLUMN `remark`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注' AFTER `sync_status`;
